<?php
require_once('conn.php');
$limit = 10;

$start = $limit*($page-1);
$query = sprintf("select * from `news` where `BigClassName`='Column' and `isok` = 1 order by `addtime` desc limit %d,%d",$start,$limit);
$result = mysql_query($query);
if($result == false)
	exit(sprintf("SQL ERROR %s<br>\nquery (%s)<br>\nin: <b>%s</b> at line: <b>%s</b><br>\n", mysql_error(), $query, __FILE__, __LINE__));
$data_list = array();
while($row = mysql_fetch_assoc($result))
{
	array_push($data_list,$row);
}
$query = sprintf("select count(1) from `news` where `BigClassName`='Column' and `isok` = 1");
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$count = $row[0];
$max_page = ceil($count/$limit);


$contributors = array();
//get locked contributors
$query = "select * from `guanli` WHERE `lock`='Y' ORDER BY `name`";
$result = mysql_query($query);
if($result == false)
	exit(sprintf("SQL ERROR %s<br>\nquery (%s)<br>\nin: <b>%s</b> at line: <b>%s</b><br>\n", mysql_error(), $query, __FILE__, __LINE__));
$contributor_username_list = '';
while($row = mysql_fetch_assoc($result))
{
	array_push($contributors,$row);
	$contributor_username_list .= sprintf("'%s',",$row['username']);
}
$locked_contributor_size = count($contributors);

//get contributors
if($locked_contributor_size  > 0)
	$query = sprintf("select distinct `n`.`addname` from `news` AS `n`,`guanli` AS `u` where `n`.`BigClassName`='Column' and `n`.`isok` = 1 AND `u`.`username` NOT IN (%s) order by `addtime` desc limit 0,%d",substr($contributor_username_list,0,-1),10-$locked_contributor_size);
else
	$query = sprintf("select distinct `n`.`addname` from `news` AS `n`  where `n`.`BigClassName`='Column' and `n`.`isok` = 1  order by `addtime` desc limit 0,%d",10);

$result = mysql_query($query);
if($result == false)
	exit(sprintf("SQL ERROR %s<br>\nquery (%s)<br>\nin: <b>%s</b> at line: <b>%s</b><br>\n", mysql_error(), $query, __FILE__, __LINE__));
$temp = array();
while($row = mysql_fetch_assoc($result))
{
	array_push($temp,$row['addname']);
}
if(count($temp) > 0)
{
	$addname_str = '';
	foreach($temp as $name)
	{
		if($addname_str == '')
			$addname_str = sprintf("'%s'",$name);
		else
			$addname_str .= sprintf(",'%s'",$name);
	}
	$query = sprintf("select * from `guanli` where `lock`='' AND `username` in (%s)",$addname_str);
	$result = mysql_query($query);
	
	if($result == false)
		exit(sprintf("SQL ERROR %s<br>\nquery (%s)<br>\nin: <b>%s</b> at line: <b>%s</b><br>\n", mysql_error(), $query, __FILE__, __LINE__));
	while($row = mysql_fetch_assoc($result))
	{
		array_push($contributors,$row);
	}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>  [ BIOS Monthly 專欄 ] </title>
<meta name="description" content=" 想看看各個城市的風景與生活樣態嗎？來Bios Monthly看看吧！我們聯繫了旅居不同城市的專欄寫手們加上台北的獨特觀察家，我們要與你一起看看我們所居住或嚮往的樣貌。 " />
<meta name="KEYWORDS" CONTENT=" 飲食, 風尚 , 行旅 , 休閒 , 評論 , Flavor , Trend , Route , Leisure , Opinion " />

<link href="css/main.css" rel="stylesheet" type="text/css" />
<script src="js/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript">
	$(document).ready(function(){
		$(".hoverFeature ,.hoverColumn,.hoverNews,.hoverEvent , .hoverRss").css("opacity","0");
		$(".hoverFeature ,.hoverColumn,.hoverNews,.hoverEvent , .hoverRss").hover(function () {
			$(this).stop().animate({
				opacity: 1
			}, "fast");
		},
		function () {
			$(this).stop().animate({
				opacity: 0
			}, "fast");
		});
		});
	</script>
   <script type="text/javascript">
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>
</head>
<body onload="MM_preloadImages('images/main-btn_over_13.gif','images/main-btn_over_15.gif','images/main-btn_over_17.gif', 'images/main-btn_over_19.gif','images/feature-btn_over_01.gif','images/feature-btn_over_02.gif','images/feature-btn_over_03.gif','images/feature-btn_over_04.gif')">
<div id="all"><!-- start #all //-->
<div id="main" class="clearfix"><!-- start #main //-->
<?php include_once('top-column.php');?>
<?php include_once('ad-bb.php');?>
<div id="contact" class="clearfix"><!-- start #contact //-->
<!-- start #list-b //-->
<?php html_rend_articles_block($data_list,$page,$max_page);?>
<!-- end #list-b //-->
<?php include_once('ad-contributor.php');?>


</div><!-- end #contact //-->
</div><!-- end #main //-->
</div><!-- end #all //-->
<?php include_once('down.php');?>
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-22189695-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>
</body>
</html>